select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseArea >= 0 and a.houseArea <= 100) and (b.cnpropertyname like '%Old house in Yanqing Road%' or b.enpropertyname like '%Old house in Yanqing Road%') order by updateTime Desc, a.dftpic desc
Core area of the former French Concession, intersection with Donghu Rd and Changle Rd, within 10 minutes walk to Changshu Station of metro line 1/7; 2 bedrooms ...
Luxury decoration, There has several cafe shops,health club,western restaurants,really very popular location which is very close to IAPM,Having a private balcon...
Top location Franch style decoration, Convenient transportation 24 hour supermarket, near a variety of Chinese and Western style restaurant, purchase farms is a...
The reality is more beautiful than you see in the picture. Super nice one bedroom house with huge outside space now is available on Yanqing Rd in FFC. This r...